All Questions
77 questions
1vote
2answers
398views
Is it worth it to use a NoSQL database only for high availability and fast reading, while already using Postgres?
We have several Postgres databases on one AWS RDS cluster (for budget reasons apparently), sharing the same resources, and my team wants to use a NoSQL database alongside it, and store data there from ...
4votes
3answers
284views
What is the difference between a key attribute store and a key value store?
Im running through a course on Cloud Academy - now known as QA - and it makes the statement that Azure Table Storage is a "Key/attribute store" and Redis cached is a "Key value store&...
1vote
1answer
5kviews
SQL or NoSQL Database for a chat application?
currently I am working on a kind of "Chat" Application. The app consists of "threads". Each of this threads consist of "subthreads" in wich a user can send a message (...
0votes
0answers
290views
How would I model my NoSQL database for a conversational bot
I'm currently developing a chatbot that will be used for booking trips. The particular party I'm interested in for now is the rider. I'm using AWS's DynamoDB, because it seemed to be the most flexible ...
2votes
3answers
511views
Do NoSQL and non-relational refer to the exact same concept?
Question as the title says. Of course, I already tried searching online, but did not find a definite answer yet. (The sources I checked imply that the terms are interchangeable, but do not state this ...
0votes
2answers
290views
Saving & Referencing different Schema Types in MongoDB (e.g. for a CMS with Building Blocks)
Say I wanted to build my own CMS system and store data in MongoDB. I would like to have a Collection called BlogArticle. Each article can have a different structure, but will be put together by the ...
-2votes
1answer
192views
Can I manage a NoSQL database with only JavaScript?
I am creating an app with Deno (a personal project), and I manage the "database" with only the Javascript code of the Deno enviroment, modifying JSON files like any other JS object. For me, ...
0votes
1answer
343views
AWS Architecture: How to search in Dynamodb?
Firstly, I want to state that this is my first time trying to build an app. I am doing this for fun, mostly as an exercise to learn system design/architecture. The goal is to build an app that would ...
1vote
3answers
3kviews
When would I pick NoSQL over SQL when dealing with partly schema-less data?
so, I'm currently developing a feature for a website of mine, which aims to gather a set of financial data from the user so the user can start and take care of a budget, as well as the website ...
-3votes
2answers
64views
Does it make sense for a large scale SaaS project to use a single all powerful SQL/RDBMS database?
Scalability seems to be a thing now. I was in a heated argument with one of my developer who insist on using MySQL for a data intensive application we are building. MySql is easy, fits the purpose and ...
-3votes
1answer
97views
Saving large files like Credit Reports in Data Store - SQL/NoSQL/ObjectStore
I am working on a project to save external credit bureau reports in database. These reports are typically big and could go from 0.5MB to 5.0 MB. Number of files will grow exponentially over the time ...
3votes
1answer
592views
Is it recommended to use schemas on non-relational databases?
I'm trying to figure out if the use of schemas on non-relational schemaless databases like MongoDB is a recommended practice or a bad practice to be avoided. I am doing research work and am looking ...
2votes
3answers
110views
How should I best structure my app when I want to sort a "parent" model by a property computed on another "child" model?
Question about OO-programming, functional programming, NoSQL, SQL databases, and software architecture Hi all, I am a intermediate-level self-taught programmer, and have been dying to get an answer ...
0votes
0answers
81views
What is the correct way of setting and then differentiating between paid and free user in Firebase / Firestore?
I am developing a mobile application that will have both free and paid versions. The way I see how I could differentiate between what is a paid and free user is to set a property isPaid on their ...
0votes
1answer
38views
Update items based on a read operations on same items is a bad practice?
DynamoDB is the database solution, I'm using to store my items. It's a NoSQL/Document database and I got a real problem on real-time updates of items. First, the saved format is like { expiredTime:...